package com.ssish.saas.eccs.mapper;

import com.ssish.saas.eccs.model.Claims;
import com.ssish.saas.eccs.model.ClaimsExample;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.ResultMap;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

public interface ClaimsMapper {
    int countByExample(ClaimsExample example);

    int deleteByExample(ClaimsExample example);

    @Delete({
        "delete from CLAIMS",
        "where CLAIMS_ID = #{claimsId,jdbcType=DECIMAL}"
    })
    int deleteByPrimaryKey(Integer claimsId);

    @Insert({
        "insert into CLAIMS (CLAIMS_ID, REFERREDPHYSICIAN, ",
        "REFERREDPHYSICIANSPECIALTY, REFERREDOPFORMNO, ",
        "CARD_NO, PAYOR_CODE, ",
        "PHYSICIAN_ID, AUTHORIZATION_CODE, ",
        "CLAIM_NO, PROVIDER_ID, PROVIDER_TYPE, ",
        "DOCTOR_NAME1, DOCTOR_NAME2, ",
        "DOCTOR_NAME3, PATIENT_NAME, ",
        "SERVICE_DATE, RECORD_NO, ",
        "SUB_RECORD_NO, CORPORATE_CODE, ",
        "SUBSIDIARY_CODE, BRANCH_CODE, ",
        "PRIMARY_DIAGNOSIS, MC_TAKEN_DAY, ",
        "CLAIM_TYPE, PLAN_ID, ",
        "COVERAGE_ID, ADMISSION_DATE, ",
        "DISCHARGEABLE_DATE, TRANSMISSION_DATE, ",
        "CLAIMS_REC_DATE, DAYS_IN_HOSPITAL, ",
        "COVERAGE_DAYS, NON_COVERAGE_DAYS, ",
        "ADMISSION_TYPE, PATIENT_PREPAID, ",
        "INS_PREPAID, DUE_TOTAL, ",
        "PAID_TOTAL, BALANCE_TOTAL, ",
        "PAID_BY_CLAIMANT, PAID_TO_CLAIMANT, ",
        "REJECTION_CODE, CLAIMS_STATUS, ",
        "COMMISSION_FLAG, APPROVAL, ",
        "APPROVED_BY, REFERRAL, ",
        "INVOICE_ID, REMARKS, ",
        "DISABILITY_NO, HOSP_INVOICE_NO, ",
        "REMARKS50, REMARKS60, ",
        "REMARKS70, REMARKS80, ",
        "PROCESSED_FLAG, EXPORT40, ",
        "EXPORT80, CHEQUE_NO, ",
        "EXPORT90, CLAIMS_PROCESS_STATUS, ",
        "CLAIMS_REF_ID, TERMINAL_ID, ",
        "TERMINAL_TYPE, AVG_LOS, ",
        "AVG_BILLS, BF_LIMIT, ",
        "SECONDARY_DIAGNOSIS, CHEQUE_DATE, ",
        "PROVIDER_NAME, PANEL_PROVIDER, ",
        "DEDUCTIBLE, DEPARTMENT, ",
        "EMPLOYEE_NAME, POLICY_NO, ",
        "NEW_IC, AGENT_CODE, ",
        "AGENCY_CODE, BROKER_CODE, ",
        "AGENT_TEAM, OFFLINE_REASON, ",
        "DOCRCV_BY, REVIEW_BY, ",
        "REVIEW_DATE, SYSTRC, ",
        "DOCSUBMIT_BY, DOCSUBMIT_DATE, ",
        "CHEQUE_SENDTO, CHEQUE_TYPE, ",
        "DELIVERY_TYPE, PAYLINK_CODE, ",
        "PAYMENT_DESCRIPTION, PAYEE_NAME, ",
        "ADDR1, ADDR2, ADDR3, ",
        "ADDR4, POSTCODE, ",
        "COUNTRY, AUTOPAY, DOCRCV_CENTRE, ",
        "THIRD_DIAGNOSIS, POLICY_YEAR, ",
        "CPT_CODE1, CPT_CODE2, ",
        "CPT_CODE3, CPT_CODE4, ",
        "CPT_CODE5, PAST_DIAGNOSIS1, ",
        "PAST_DIAGNOSIS1_DUR, PAST_DIAGNOSIS2, ",
        "PAST_DIAGNOSIS2_DUR, BODY_PART1, ",
        "BODY_PART2, BODY_PART3, ",
        "REFERBY_PHYSICIAN, WARNMSG, ",
        "ERRMSG, AGENT_UNIT, ",
        "ADVANCE_PAYMENT, AGENT_HPNO, ",
        "CURRCD, CURRRT, ",
        "ENGLISH_NAME, EST_LOS, ",
        "EST_BILLS, SURGICAL_DATE, ",
        "CURRCD_ORIG, CURRRT_ORIG, ",
        "DUE_TOTAL_ORIG, BANKACCNO, ",
        "LIABILITY_AMT, SELFPAID_COLLECTDT, ",
        "SELFPAID_UPDBY, SELFPAID_UPDDT, ",
        "SELFPAID_REM, INTERFACE_CLAIM_NO, ",
        "PATIENT_HPNO, ACCIDENT_DATE, ",
        "SURGICAL, ACCIDENTAL, ",
        "EMERGENCY, NOTIFICATION_DATE, ",
        "DIAGNOSIS_REMARK, CPT_REMARK, ",
        "CHEQUE_REMARK, REMINDER, ",
        "COINSRCAP, PRIVATE_REMARK, ",
        "PREGNANT_MONTH, OUTPATIENT_TREATMENT, ",
        "ADMISSION_REFERRAL, CLAIMS_RELATED, ",
        "PAYEE_ICNO, POLICY_STATUS, ",
        "SMOKER, THIRD_PARTY_POLICY, ",
        "POLICY_ENDORSEMENT, MEMBER_ENDORSEMENT, ",
        "PV_NO, REJECTION_NOTE, ",
        "COINSR_BY_CLAIMANT, ORIGIN_CODE, ",
        "PREMIUM_PAID_DATE, INTERFACE_CLAIM_NO2, ",
        "POLICY_ENDORSEMENT_CODE, REVIEW_REMARK, ",
        "ADMISSION_REMARK, ADMISSION_PRIVATE_REMARK, ",
        "PLAN_START_DATE, PLAN_END_DATE, ",
        "POLICY_STATUS_CHANGE_DATE, MEMBER_STATUS, ",
        "POLICY_START_DATE, MNRB_RISK, ",
        "FOURTH_DIAGNOSIS, FIFTH_DIAGNOSIS, ",
        "INTERFACE_CLAIM_NO3, CHEQUE_DESPATCH_DATE, ",
        "CHEQUE_DESPATCH_BY, SCALEDOWN_BY_CLAIMANT, ",
        "SCALEDOWNCAP, PATIENT_EMAIL, ",
        "AGENT_EMAIL, PREAUTH_BENEFIT, ",
        "CENTRE_CODE, SELFPAID_COLLECTAMT, ",
        "B4ADJUST_DUE_TOTAL_ORIG, B4ADJUST_DUE_TOTAL, ",
        "B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_PAID_BY_CLAIMANT, ",
        "AMT_SETTLE_BY_PAYOR, AMT_SETTLE_BY_TPA, ",
        "AMT_SETTLE_BY_PAYOR_DBNNO, AMT_SETTLE_BY_TPA_DBNNO, ",
        "SELFPAID_RCPTNO, SELFPAID_CRNNO, ",
        "HOSP_INVOICE_AMT_ORIG, PREMIUM_GRACE_DATE, ",
        "MEMBER_PV_NO, MEMBER_CHEQUE_NO, ",
        "MEMBER_CHEQUE_DATE, HOSP_INVOICE_TYPE, ",
        "PREAUTH_REQUIRED_TRIGGER, EBANK_BATCHNO, ",
        "EBANK_DATE, EBANK_RESPONSE, ",
        "BATCH_NO, BATCH_DATE, ",
        "CLAIMS_SNO, CLIENT_ID, ",
        "GSTRT, GSTAMT_ORIG, ",
        "UNIT, COST_CENTER, ",
        "SERVICE_FEE, VATRT, ",
        "VATAMT_ORIG, WHTRT, ",
        "WHTAMT_ORIG, LAST_TRANSACTION_DATE, ",
        "DESIGNATION, MC_START_DATE, ",
        "MC_END_DATE, PACKAGE_CODE, ",
        "PACKAGE_DESC, PACKAGE_FEE, ",
        "LEGAL_ENTITY, OFFICE_CODE, ",
        "SUBSIDIARY, DIVISION, ",
        "SUBDEPARTMENT, EMPLOYMENT_LOCATION, ",
        "EMPLOYMENT_REGION, EMPLOYMENT_CATEGORY, ",
        "EMPLOYMENT_DATE, AMT_DISCOUNT_ORIG, ",
        "AMT_DISCOUNT_MEMBER_ORIG, OCCUPATION, ",
        "LAST_CLAIMS_STATUS_DATE, SERVICE_FEE_FORMULA, ",
        "SERVICE_FEE_FORMULA_RATE, SERVICE_FEE_GSTRT, ",
        "SERVICE_FEE_VATRT, SERVICE_FEE_GSTAMT, ",
        "SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE, ",
        "PAYOR_SERVICE_FEE_GSTRT, PAYOR_SERVICE_FEE_VATRT, ",
        "PAYOR_SERVICE_FEE_GSTAMT, PAYOR_SERVICE_FEE_VATAMT, ",
        "PAYOR_SERVICE_FEE_INVOICE_NO, MEMBER_CONTROL_NO, ",
        "DUE_TOTAL_GSTAMT_ORIG, DUE_TOTAL_VATAMT_ORIG, ",
        "REFERRAL_PROVIDER_ID, CPF_PREPAID, ",
        "CURRCD_PAYOR, CURRRT_PAYOR, ",
        "XBORDER, MERCHANT_CODE, ",
        "SELFPAID_BY_MEMBER, SELFPAID_BY_PAYOR, ",
        "SELFPAID_BY_PROVIDER, SELFPAID_BY_TPA, ",
        "EST_LOS_ICU, USER_CODE, ",
        "LASTEDIT_DATE, ASSIGNED_CODE, ",
        "BIRTH_DATE, GENDER, ",
        "CARDSITEID, PROVSITEID, ",
        "TAXINV_RECEIVE_DATE, ORIGBILL_DESPATCH_DATE, ",
        "PREPAID_PROVIDER_AMOUNT, PROVIDER_PAYMENT_DUE_DATE, ",
        "PROVIDER_CRTCD, CLAIMSLIST_RECEIVE_DATE, ",
        "LAST_TRANSACTION_STATUS, LAST_TRANSACTION_REASON, ",
        "INS_PREPAID_CRCD, ADMISSION_REASON, ",
        "CAUSE_AND_PATHOLOGY, POSSIBILITY_RELAPSE, ",
        "UNDERLYING_MEDICAL_COND, PROGNOSIS, ",
        "DISCHARGE_MEDICATION, FOLLOWUP_INSTRUCTION, ",
        "OTHER_THERAPEUTIC_PROCEDURE, MRN)",
        "values (#{claimsId,jdbcType=DECIMAL}, #{referredphysician,jdbcType=VARCHAR}, ",
        "#{referredphysicianspecialty,jdbcType=VARCHAR}, #{referredopformno,jdbcType=CHAR}, ",
        "#{cardNo,jdbcType=DECIMAL}, #{payorCode,jdbcType=CHAR}, ",
        "#{physicianId,jdbcType=VARCHAR}, #{authorizationCode,jdbcType=VARCHAR}, ",
        "#{claimNo,jdbcType=CHAR}, #{providerId,jdbcType=CHAR}, #{providerType,jdbcType=VARCHAR}, ",
        "#{doctorName1,jdbcType=VARCHAR}, #{doctorName2,jdbcType=VARCHAR}, ",
        "#{doctorName3,jdbcType=VARCHAR}, #{patientName,jdbcType=VARCHAR}, ",
        "#{serviceDate,jdbcType=TIMESTAMP}, #{recordNo,jdbcType=CHAR}, ",
        "#{subRecordNo,jdbcType=CHAR}, #{corporateCode,jdbcType=VARCHAR}, ",
        "#{subsidiaryCode,jdbcType=VARCHAR}, #{branchCode,jdbcType=OTHER}, ",
        "#{primaryDiagnosis,jdbcType=VARCHAR}, #{mcTakenDay,jdbcType=DECIMAL}, ",
        "#{claimType,jdbcType=VARCHAR}, #{planId,jdbcType=VARCHAR}, ",
        "#{coverageId,jdbcType=CHAR}, #{admissionDate,jdbcType=TIMESTAMP}, ",
        "#{dischargeableDate,jdbcType=TIMESTAMP}, #{transmissionDate,jdbcType=TIMESTAMP}, ",
        "#{claimsRecDate,jdbcType=TIMESTAMP}, #{daysInHospital,jdbcType=DECIMAL}, ",
        "#{coverageDays,jdbcType=DECIMAL}, #{nonCoverageDays,jdbcType=DECIMAL}, ",
        "#{admissionType,jdbcType=VARCHAR}, #{patientPrepaid,jdbcType=DECIMAL}, ",
        "#{insPrepaid,jdbcType=DECIMAL}, #{dueTotal,jdbcType=DECIMAL}, ",
        "#{paidTotal,jdbcType=DECIMAL}, #{balanceTotal,jdbcType=DECIMAL}, ",
        "#{paidByClaimant,jdbcType=DECIMAL}, #{paidToClaimant,jdbcType=DECIMAL}, ",
        "#{rejectionCode,jdbcType=VARCHAR}, #{claimsStatus,jdbcType=CHAR}, ",
        "#{commissionFlag,jdbcType=VARCHAR}, #{approval,jdbcType=VARCHAR}, ",
        "#{approvedBy,jdbcType=VARCHAR}, #{referral,jdbcType=VARCHAR}, ",
        "#{invoiceId,jdbcType=VARCHAR}, #{remarks,jdbcType=VARCHAR}, ",
        "#{disabilityNo,jdbcType=CHAR}, #{hospInvoiceNo,jdbcType=VARCHAR}, ",
        "#{remarks50,jdbcType=CHAR}, #{remarks60,jdbcType=CHAR}, ",
        "#{remarks70,jdbcType=CHAR}, #{remarks80,jdbcType=CHAR}, ",
        "#{processedFlag,jdbcType=CHAR}, #{export40,jdbcType=CHAR}, ",
        "#{export80,jdbcType=CHAR}, #{chequeNo,jdbcType=VARCHAR}, ",
        "#{export90,jdbcType=CHAR}, #{claimsProcessStatus,jdbcType=CHAR}, ",
        "#{claimsRefId,jdbcType=DECIMAL}, #{terminalId,jdbcType=DECIMAL}, ",
        "#{terminalType,jdbcType=CHAR}, #{avgLos,jdbcType=DECIMAL}, ",
        "#{avgBills,jdbcType=DECIMAL}, #{bfLimit,jdbcType=DECIMAL}, ",
        "#{secondaryDiagnosis,jdbcType=VARCHAR}, #{chequeDate,jdbcType=TIMESTAMP}, ",
        "#{providerName,jdbcType=OTHER}, #{panelProvider,jdbcType=CHAR}, ",
        "#{deductible,jdbcType=DECIMAL}, #{department,jdbcType=VARCHAR}, ",
        "#{employeeName,jdbcType=VARCHAR}, #{policyNo,jdbcType=VARCHAR}, ",
        "#{newIc,jdbcType=VARCHAR}, #{agentCode,jdbcType=VARCHAR}, ",
        "#{agencyCode,jdbcType=VARCHAR}, #{brokerCode,jdbcType=VARCHAR}, ",
        "#{agentTeam,jdbcType=VARCHAR}, #{offlineReason,jdbcType=VARCHAR}, ",
        "#{docrcvBy,jdbcType=VARCHAR}, #{reviewBy,jdbcType=VARCHAR}, ",
        "#{reviewDate,jdbcType=TIMESTAMP}, #{systrc,jdbcType=VARCHAR}, ",
        "#{docsubmitBy,jdbcType=VARCHAR}, #{docsubmitDate,jdbcType=TIMESTAMP}, ",
        "#{chequeSendto,jdbcType=VARCHAR}, #{chequeType,jdbcType=VARCHAR}, ",
        "#{deliveryType,jdbcType=VARCHAR}, #{paylinkCode,jdbcType=VARCHAR}, ",
        "#{paymentDescription,jdbcType=VARCHAR}, #{payeeName,jdbcType=VARCHAR}, ",
        "#{addr1,jdbcType=VARCHAR}, #{addr2,jdbcType=VARCHAR}, #{addr3,jdbcType=VARCHAR}, ",
        "#{addr4,jdbcType=VARCHAR}, #{postcode,jdbcType=VARCHAR}, ",
        "#{country,jdbcType=VARCHAR}, #{autopay,jdbcType=CHAR}, #{docrcvCentre,jdbcType=VARCHAR}, ",
        "#{thirdDiagnosis,jdbcType=VARCHAR}, #{policyYear,jdbcType=DECIMAL}, ",
        "#{cptCode1,jdbcType=VARCHAR}, #{cptCode2,jdbcType=VARCHAR}, ",
        "#{cptCode3,jdbcType=VARCHAR}, #{cptCode4,jdbcType=VARCHAR}, ",
        "#{cptCode5,jdbcType=VARCHAR}, #{pastDiagnosis1,jdbcType=VARCHAR}, ",
        "#{pastDiagnosis1Dur,jdbcType=DECIMAL}, #{pastDiagnosis2,jdbcType=VARCHAR}, ",
        "#{pastDiagnosis2Dur,jdbcType=DECIMAL}, #{bodyPart1,jdbcType=VARCHAR}, ",
        "#{bodyPart2,jdbcType=VARCHAR}, #{bodyPart3,jdbcType=VARCHAR}, ",
        "#{referbyPhysician,jdbcType=VARCHAR}, #{warnmsg,jdbcType=VARCHAR}, ",
        "#{errmsg,jdbcType=VARCHAR}, #{agentUnit,jdbcType=VARCHAR}, ",
        "#{advancePayment,jdbcType=CHAR}, #{agentHpno,jdbcType=VARCHAR}, ",
        "#{currcd,jdbcType=VARCHAR}, #{currrt,jdbcType=DECIMAL}, ",
        "#{englishName,jdbcType=VARCHAR}, #{estLos,jdbcType=DECIMAL}, ",
        "#{estBills,jdbcType=DECIMAL}, #{surgicalDate,jdbcType=TIMESTAMP}, ",
        "#{currcdOrig,jdbcType=VARCHAR}, #{currrtOrig,jdbcType=DECIMAL}, ",
        "#{dueTotalOrig,jdbcType=DECIMAL}, #{bankaccno,jdbcType=VARCHAR}, ",
        "#{liabilityAmt,jdbcType=DECIMAL}, #{selfpaidCollectdt,jdbcType=TIMESTAMP}, ",
        "#{selfpaidUpdby,jdbcType=VARCHAR}, #{selfpaidUpddt,jdbcType=TIMESTAMP}, ",
        "#{selfpaidRem,jdbcType=VARCHAR}, #{interfaceClaimNo,jdbcType=VARCHAR}, ",
        "#{patientHpno,jdbcType=VARCHAR}, #{accidentDate,jdbcType=TIMESTAMP}, ",
        "#{surgical,jdbcType=CHAR}, #{accidental,jdbcType=CHAR}, ",
        "#{emergency,jdbcType=CHAR}, #{notificationDate,jdbcType=TIMESTAMP}, ",
        "#{diagnosisRemark,jdbcType=VARCHAR}, #{cptRemark,jdbcType=VARCHAR}, ",
        "#{chequeRemark,jdbcType=VARCHAR}, #{reminder,jdbcType=DECIMAL}, ",
        "#{coinsrcap,jdbcType=DECIMAL}, #{privateRemark,jdbcType=VARCHAR}, ",
        "#{pregnantMonth,jdbcType=DECIMAL}, #{outpatientTreatment,jdbcType=CHAR}, ",
        "#{admissionReferral,jdbcType=VARCHAR}, #{claimsRelated,jdbcType=VARCHAR}, ",
        "#{payeeIcno,jdbcType=VARCHAR}, #{policyStatus,jdbcType=DECIMAL}, ",
        "#{smoker,jdbcType=CHAR}, #{thirdPartyPolicy,jdbcType=CHAR}, ",
        "#{policyEndorsement,jdbcType=VARCHAR}, #{memberEndorsement,jdbcType=VARCHAR}, ",
        "#{pvNo,jdbcType=VARCHAR}, #{rejectionNote,jdbcType=VARCHAR}, ",
        "#{coinsrByClaimant,jdbcType=DECIMAL}, #{originCode,jdbcType=VARCHAR}, ",
        "#{premiumPaidDate,jdbcType=TIMESTAMP}, #{interfaceClaimNo2,jdbcType=VARCHAR}, ",
        "#{policyEndorsementCode,jdbcType=VARCHAR}, #{reviewRemark,jdbcType=VARCHAR}, ",
        "#{admissionRemark,jdbcType=VARCHAR}, #{admissionPrivateRemark,jdbcType=VARCHAR}, ",
        "#{planStartDate,jdbcType=TIMESTAMP}, #{planEndDate,jdbcType=TIMESTAMP}, ",
        "#{policyStatusChangeDate,jdbcType=TIMESTAMP}, #{memberStatus,jdbcType=VARCHAR}, ",
        "#{policyStartDate,jdbcType=TIMESTAMP}, #{mnrbRisk,jdbcType=VARCHAR}, ",
        "#{fourthDiagnosis,jdbcType=VARCHAR}, #{fifthDiagnosis,jdbcType=VARCHAR}, ",
        "#{interfaceClaimNo3,jdbcType=VARCHAR}, #{chequeDespatchDate,jdbcType=TIMESTAMP}, ",
        "#{chequeDespatchBy,jdbcType=VARCHAR}, #{scaledownByClaimant,jdbcType=DECIMAL}, ",
        "#{scaledowncap,jdbcType=DECIMAL}, #{patientEmail,jdbcType=VARCHAR}, ",
        "#{agentEmail,jdbcType=VARCHAR}, #{preauthBenefit,jdbcType=VARCHAR}, ",
        "#{centreCode,jdbcType=VARCHAR}, #{selfpaidCollectamt,jdbcType=DECIMAL}, ",
        "#{b4adjustDueTotalOrig,jdbcType=DECIMAL}, #{b4adjustDueTotal,jdbcType=DECIMAL}, ",
        "#{b4adjustPaidToClaimant,jdbcType=DECIMAL}, #{b4adjustPaidByClaimant,jdbcType=DECIMAL}, ",
        "#{amtSettleByPayor,jdbcType=DECIMAL}, #{amtSettleByTpa,jdbcType=DECIMAL}, ",
        "#{amtSettleByPayorDbnno,jdbcType=VARCHAR}, #{amtSettleByTpaDbnno,jdbcType=VARCHAR}, ",
        "#{selfpaidRcptno,jdbcType=VARCHAR}, #{selfpaidCrnno,jdbcType=VARCHAR}, ",
        "#{hospInvoiceAmtOrig,jdbcType=DECIMAL}, #{premiumGraceDate,jdbcType=TIMESTAMP}, ",
        "#{memberPvNo,jdbcType=VARCHAR}, #{memberChequeNo,jdbcType=VARCHAR}, ",
        "#{memberChequeDate,jdbcType=TIMESTAMP}, #{hospInvoiceType,jdbcType=CHAR}, ",
        "#{preauthRequiredTrigger,jdbcType=VARCHAR}, #{ebankBatchno,jdbcType=VARCHAR}, ",
        "#{ebankDate,jdbcType=TIMESTAMP}, #{ebankResponse,jdbcType=VARCHAR}, ",
        "#{batchNo,jdbcType=VARCHAR}, #{batchDate,jdbcType=TIMESTAMP}, ",
        "#{claimsSno,jdbcType=DECIMAL}, #{clientId,jdbcType=VARCHAR}, ",
        "#{gstrt,jdbcType=DECIMAL}, #{gstamtOrig,jdbcType=DECIMAL}, ",
        "#{unit,jdbcType=VARCHAR}, #{costCenter,jdbcType=VARCHAR}, ",
        "#{serviceFee,jdbcType=DECIMAL}, #{vatrt,jdbcType=DECIMAL}, ",
        "#{vatamtOrig,jdbcType=DECIMAL}, #{whtrt,jdbcType=DECIMAL}, ",
        "#{whtamtOrig,jdbcType=DECIMAL}, #{lastTransactionDate,jdbcType=TIMESTAMP}, ",
        "#{designation,jdbcType=VARCHAR}, #{mcStartDate,jdbcType=TIMESTAMP}, ",
        "#{mcEndDate,jdbcType=TIMESTAMP}, #{packageCode,jdbcType=VARCHAR}, ",
        "#{packageDesc,jdbcType=OTHER}, #{packageFee,jdbcType=DECIMAL}, ",
        "#{legalEntity,jdbcType=VARCHAR}, #{officeCode,jdbcType=VARCHAR}, ",
        "#{subsidiary,jdbcType=VARCHAR}, #{division,jdbcType=VARCHAR}, ",
        "#{subdepartment,jdbcType=VARCHAR}, #{employmentLocation,jdbcType=VARCHAR}, ",
        "#{employmentRegion,jdbcType=VARCHAR}, #{employmentCategory,jdbcType=VARCHAR}, ",
        "#{employmentDate,jdbcType=TIMESTAMP}, #{amtDiscountOrig,jdbcType=DECIMAL}, ",
        "#{amtDiscountMemberOrig,jdbcType=DECIMAL}, #{occupation,jdbcType=VARCHAR}, ",
        "#{lastClaimsStatusDate,jdbcType=TIMESTAMP}, #{serviceFeeFormula,jdbcType=DECIMAL}, ",
        "#{serviceFeeFormulaRate,jdbcType=DECIMAL}, #{serviceFeeGstrt,jdbcType=DECIMAL}, ",
        "#{serviceFeeVatrt,jdbcType=DECIMAL}, #{serviceFeeGstamt,jdbcType=DECIMAL}, ",
        "#{serviceFeeVatamt,jdbcType=DECIMAL}, #{payorServiceFee,jdbcType=DECIMAL}, ",
        "#{payorServiceFeeGstrt,jdbcType=DECIMAL}, #{payorServiceFeeVatrt,jdbcType=DECIMAL}, ",
        "#{payorServiceFeeGstamt,jdbcType=DECIMAL}, #{payorServiceFeeVatamt,jdbcType=DECIMAL}, ",
        "#{payorServiceFeeInvoiceNo,jdbcType=VARCHAR}, #{memberControlNo,jdbcType=VARCHAR}, ",
        "#{dueTotalGstamtOrig,jdbcType=DECIMAL}, #{dueTotalVatamtOrig,jdbcType=DECIMAL}, ",
        "#{referralProviderId,jdbcType=CHAR}, #{cpfPrepaid,jdbcType=DECIMAL}, ",
        "#{currcdPayor,jdbcType=VARCHAR}, #{currrtPayor,jdbcType=DECIMAL}, ",
        "#{xborder,jdbcType=CHAR}, #{merchantCode,jdbcType=VARCHAR}, ",
        "#{selfpaidByMember,jdbcType=DECIMAL}, #{selfpaidByPayor,jdbcType=DECIMAL}, ",
        "#{selfpaidByProvider,jdbcType=DECIMAL}, #{selfpaidByTpa,jdbcType=DECIMAL}, ",
        "#{estLosIcu,jdbcType=DECIMAL}, #{userCode,jdbcType=VARCHAR}, ",
        "#{lasteditDate,jdbcType=TIMESTAMP}, #{assignedCode,jdbcType=VARCHAR}, ",
        "#{birthDate,jdbcType=TIMESTAMP}, #{gender,jdbcType=CHAR}, ",
        "#{cardsiteid,jdbcType=VARCHAR}, #{provsiteid,jdbcType=VARCHAR}, ",
        "#{taxinvReceiveDate,jdbcType=TIMESTAMP}, #{origbillDespatchDate,jdbcType=TIMESTAMP}, ",
        "#{prepaidProviderAmount,jdbcType=DECIMAL}, #{providerPaymentDueDate,jdbcType=TIMESTAMP}, ",
        "#{providerCrtcd,jdbcType=VARCHAR}, #{claimslistReceiveDate,jdbcType=TIMESTAMP}, ",
        "#{lastTransactionStatus,jdbcType=CHAR}, #{lastTransactionReason,jdbcType=VARCHAR}, ",
        "#{insPrepaidCrcd,jdbcType=VARCHAR}, #{admissionReason,jdbcType=OTHER}, ",
        "#{causeAndPathology,jdbcType=OTHER}, #{possibilityRelapse,jdbcType=OTHER}, ",
        "#{underlyingMedicalCond,jdbcType=OTHER}, #{prognosis,jdbcType=OTHER}, ",
        "#{dischargeMedication,jdbcType=OTHER}, #{followupInstruction,jdbcType=OTHER}, ",
        "#{otherTherapeuticProcedure,jdbcType=OTHER}, #{mrn,jdbcType=VARCHAR})"
    })
    int insert(Claims record);

    int insertSelective(Claims record);

    List<Claims> selectByExample(ClaimsExample example);

    @Select({
        "select",
        "CLAIMS_ID, REFERREDPHYSICIAN, REFERREDPHYSICIANSPECIALTY, REFERREDOPFORMNO, ",
        "CARD_NO, PAYOR_CODE, PHYSICIAN_ID, AUTHORIZATION_CODE, CLAIM_NO, PROVIDER_ID, ",
        "PROVIDER_TYPE, DOCTOR_NAME1, DOCTOR_NAME2, DOCTOR_NAME3, PATIENT_NAME, SERVICE_DATE, ",
        "RECORD_NO, SUB_RECORD_NO, CORPORATE_CODE, SUBSIDIARY_CODE, BRANCH_CODE, PRIMARY_DIAGNOSIS, ",
        "MC_TAKEN_DAY, CLAIM_TYPE, PLAN_ID, COVERAGE_ID, ADMISSION_DATE, DISCHARGEABLE_DATE, ",
        "TRANSMISSION_DATE, CLAIMS_REC_DATE, DAYS_IN_HOSPITAL, COVERAGE_DAYS, NON_COVERAGE_DAYS, ",
        "ADMISSION_TYPE, PATIENT_PREPAID, INS_PREPAID, DUE_TOTAL, PAID_TOTAL, BALANCE_TOTAL, ",
        "PAID_BY_CLAIMANT, PAID_TO_CLAIMANT, REJECTION_CODE, CLAIMS_STATUS, COMMISSION_FLAG, ",
        "APPROVAL, APPROVED_BY, REFERRAL, INVOICE_ID, REMARKS, DISABILITY_NO, HOSP_INVOICE_NO, ",
        "REMARKS50, REMARKS60, REMARKS70, REMARKS80, PROCESSED_FLAG, EXPORT40, EXPORT80, ",
        "CHEQUE_NO, EXPORT90, CLAIMS_PROCESS_STATUS, CLAIMS_REF_ID, TERMINAL_ID, TERMINAL_TYPE, ",
        "AVG_LOS, AVG_BILLS, BF_LIMIT, SECONDARY_DIAGNOSIS, CHEQUE_DATE, PROVIDER_NAME, ",
        "PANEL_PROVIDER, DEDUCTIBLE, DEPARTMENT, EMPLOYEE_NAME, POLICY_NO, NEW_IC, AGENT_CODE, ",
        "AGENCY_CODE, BROKER_CODE, AGENT_TEAM, OFFLINE_REASON, DOCRCV_BY, REVIEW_BY, ",
        "REVIEW_DATE, SYSTRC, DOCSUBMIT_BY, DOCSUBMIT_DATE, CHEQUE_SENDTO, CHEQUE_TYPE, ",
        "DELIVERY_TYPE, PAYLINK_CODE, PAYMENT_DESCRIPTION, PAYEE_NAME, ADDR1, ADDR2, ",
        "ADDR3, ADDR4, POSTCODE, COUNTRY, AUTOPAY, DOCRCV_CENTRE, THIRD_DIAGNOSIS, POLICY_YEAR, ",
        "CPT_CODE1, CPT_CODE2, CPT_CODE3, CPT_CODE4, CPT_CODE5, PAST_DIAGNOSIS1, PAST_DIAGNOSIS1_DUR, ",
        "PAST_DIAGNOSIS2, PAST_DIAGNOSIS2_DUR, BODY_PART1, BODY_PART2, BODY_PART3, REFERBY_PHYSICIAN, ",
        "WARNMSG, ERRMSG, AGENT_UNIT, ADVANCE_PAYMENT, AGENT_HPNO, CURRCD, CURRRT, ENGLISH_NAME, ",
        "EST_LOS, EST_BILLS, SURGICAL_DATE, CURRCD_ORIG, CURRRT_ORIG, DUE_TOTAL_ORIG, ",
        "BANKACCNO, LIABILITY_AMT, SELFPAID_COLLECTDT, SELFPAID_UPDBY, SELFPAID_UPDDT, ",
        "SELFPAID_REM, INTERFACE_CLAIM_NO, PATIENT_HPNO, ACCIDENT_DATE, SURGICAL, ACCIDENTAL, ",
        "EMERGENCY, NOTIFICATION_DATE, DIAGNOSIS_REMARK, CPT_REMARK, CHEQUE_REMARK, REMINDER, ",
        "COINSRCAP, PRIVATE_REMARK, PREGNANT_MONTH, OUTPATIENT_TREATMENT, ADMISSION_REFERRAL, ",
        "CLAIMS_RELATED, PAYEE_ICNO, POLICY_STATUS, SMOKER, THIRD_PARTY_POLICY, POLICY_ENDORSEMENT, ",
        "MEMBER_ENDORSEMENT, PV_NO, REJECTION_NOTE, COINSR_BY_CLAIMANT, ORIGIN_CODE, ",
        "PREMIUM_PAID_DATE, INTERFACE_CLAIM_NO2, POLICY_ENDORSEMENT_CODE, REVIEW_REMARK, ",
        "ADMISSION_REMARK, ADMISSION_PRIVATE_REMARK, PLAN_START_DATE, PLAN_END_DATE, ",
        "POLICY_STATUS_CHANGE_DATE, MEMBER_STATUS, POLICY_START_DATE, MNRB_RISK, FOURTH_DIAGNOSIS, ",
        "FIFTH_DIAGNOSIS, INTERFACE_CLAIM_NO3, CHEQUE_DESPATCH_DATE, CHEQUE_DESPATCH_BY, ",
        "SCALEDOWN_BY_CLAIMANT, SCALEDOWNCAP, PATIENT_EMAIL, AGENT_EMAIL, PREAUTH_BENEFIT, ",
        "CENTRE_CODE, SELFPAID_COLLECTAMT, B4ADJUST_DUE_TOTAL_ORIG, B4ADJUST_DUE_TOTAL, ",
        "B4ADJUST_PAID_TO_CLAIMANT, B4ADJUST_PAID_BY_CLAIMANT, AMT_SETTLE_BY_PAYOR, AMT_SETTLE_BY_TPA, ",
        "AMT_SETTLE_BY_PAYOR_DBNNO, AMT_SETTLE_BY_TPA_DBNNO, SELFPAID_RCPTNO, SELFPAID_CRNNO, ",
        "HOSP_INVOICE_AMT_ORIG, PREMIUM_GRACE_DATE, MEMBER_PV_NO, MEMBER_CHEQUE_NO, MEMBER_CHEQUE_DATE, ",
        "HOSP_INVOICE_TYPE, PREAUTH_REQUIRED_TRIGGER, EBANK_BATCHNO, EBANK_DATE, EBANK_RESPONSE, ",
        "BATCH_NO, BATCH_DATE, CLAIMS_SNO, CLIENT_ID, GSTRT, GSTAMT_ORIG, UNIT, COST_CENTER, ",
        "SERVICE_FEE, VATRT, VATAMT_ORIG, WHTRT, WHTAMT_ORIG, LAST_TRANSACTION_DATE, ",
        "DESIGNATION, MC_START_DATE, MC_END_DATE, PACKAGE_CODE, PACKAGE_DESC, PACKAGE_FEE, ",
        "LEGAL_ENTITY, OFFICE_CODE, SUBSIDIARY, DIVISION, SUBDEPARTMENT, EMPLOYMENT_LOCATION, ",
        "EMPLOYMENT_REGION, EMPLOYMENT_CATEGORY, EMPLOYMENT_DATE, AMT_DISCOUNT_ORIG, ",
        "AMT_DISCOUNT_MEMBER_ORIG, OCCUPATION, LAST_CLAIMS_STATUS_DATE, SERVICE_FEE_FORMULA, ",
        "SERVICE_FEE_FORMULA_RATE, SERVICE_FEE_GSTRT, SERVICE_FEE_VATRT, SERVICE_FEE_GSTAMT, ",
        "SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE, PAYOR_SERVICE_FEE_GSTRT, PAYOR_SERVICE_FEE_VATRT, ",
        "PAYOR_SERVICE_FEE_GSTAMT, PAYOR_SERVICE_FEE_VATAMT, PAYOR_SERVICE_FEE_INVOICE_NO, ",
        "MEMBER_CONTROL_NO, DUE_TOTAL_GSTAMT_ORIG, DUE_TOTAL_VATAMT_ORIG, REFERRAL_PROVIDER_ID, ",
        "CPF_PREPAID, CURRCD_PAYOR, CURRRT_PAYOR, XBORDER, MERCHANT_CODE, SELFPAID_BY_MEMBER, ",
        "SELFPAID_BY_PAYOR, SELFPAID_BY_PROVIDER, SELFPAID_BY_TPA, EST_LOS_ICU, USER_CODE, ",
        "LASTEDIT_DATE, ASSIGNED_CODE, BIRTH_DATE, GENDER, CARDSITEID, PROVSITEID, TAXINV_RECEIVE_DATE, ",
        "ORIGBILL_DESPATCH_DATE, PREPAID_PROVIDER_AMOUNT, PROVIDER_PAYMENT_DUE_DATE, ",
        "PROVIDER_CRTCD, CLAIMSLIST_RECEIVE_DATE, LAST_TRANSACTION_STATUS, LAST_TRANSACTION_REASON, ",
        "INS_PREPAID_CRCD, ADMISSION_REASON, CAUSE_AND_PATHOLOGY, POSSIBILITY_RELAPSE, ",
        "UNDERLYING_MEDICAL_COND, PROGNOSIS, DISCHARGE_MEDICATION, FOLLOWUP_INSTRUCTION, ",
        "OTHER_THERAPEUTIC_PROCEDURE, MRN",
        "from CLAIMS",
        "where CLAIMS_ID = #{claimsId,jdbcType=DECIMAL}"
    })
    @ResultMap("BaseResultMap")
    Claims selectByPrimaryKey(Integer claimsId);

    int updateByExampleSelective(@Param("record") Claims record, @Param("example") ClaimsExample example);

    int updateByExample(@Param("record") Claims record, @Param("example") ClaimsExample example);

    int updateByPrimaryKeySelective(Claims record);

    @Update({
        "update CLAIMS",
        "set REFERREDPHYSICIAN = #{referredphysician,jdbcType=VARCHAR},",
          "REFERREDPHYSICIANSPECIALTY = #{referredphysicianspecialty,jdbcType=VARCHAR},",
          "REFERREDOPFORMNO = #{referredopformno,jdbcType=CHAR},",
          "CARD_NO = #{cardNo,jdbcType=DECIMAL},",
          "PAYOR_CODE = #{payorCode,jdbcType=CHAR},",
          "PHYSICIAN_ID = #{physicianId,jdbcType=VARCHAR},",
          "AUTHORIZATION_CODE = #{authorizationCode,jdbcType=VARCHAR},",
          "CLAIM_NO = #{claimNo,jdbcType=CHAR},",
          "PROVIDER_ID = #{providerId,jdbcType=CHAR},",
          "PROVIDER_TYPE = #{providerType,jdbcType=VARCHAR},",
          "DOCTOR_NAME1 = #{doctorName1,jdbcType=VARCHAR},",
          "DOCTOR_NAME2 = #{doctorName2,jdbcType=VARCHAR},",
          "DOCTOR_NAME3 = #{doctorName3,jdbcType=VARCHAR},",
          "PATIENT_NAME = #{patientName,jdbcType=VARCHAR},",
          "SERVICE_DATE = #{serviceDate,jdbcType=TIMESTAMP},",
          "RECORD_NO = #{recordNo,jdbcType=CHAR},",
          "SUB_RECORD_NO = #{subRecordNo,jdbcType=CHAR},",
          "CORPORATE_CODE = #{corporateCode,jdbcType=VARCHAR},",
          "SUBSIDIARY_CODE = #{subsidiaryCode,jdbcType=VARCHAR},",
          "BRANCH_CODE = #{branchCode,jdbcType=OTHER},",
          "PRIMARY_DIAGNOSIS = #{primaryDiagnosis,jdbcType=VARCHAR},",
          "MC_TAKEN_DAY = #{mcTakenDay,jdbcType=DECIMAL},",
          "CLAIM_TYPE = #{claimType,jdbcType=VARCHAR},",
          "PLAN_ID = #{planId,jdbcType=VARCHAR},",
          "COVERAGE_ID = #{coverageId,jdbcType=CHAR},",
          "ADMISSION_DATE = #{admissionDate,jdbcType=TIMESTAMP},",
          "DISCHARGEABLE_DATE = #{dischargeableDate,jdbcType=TIMESTAMP},",
          "TRANSMISSION_DATE = #{transmissionDate,jdbcType=TIMESTAMP},",
          "CLAIMS_REC_DATE = #{claimsRecDate,jdbcType=TIMESTAMP},",
          "DAYS_IN_HOSPITAL = #{daysInHospital,jdbcType=DECIMAL},",
          "COVERAGE_DAYS = #{coverageDays,jdbcType=DECIMAL},",
          "NON_COVERAGE_DAYS = #{nonCoverageDays,jdbcType=DECIMAL},",
          "ADMISSION_TYPE = #{admissionType,jdbcType=VARCHAR},",
          "PATIENT_PREPAID = #{patientPrepaid,jdbcType=DECIMAL},",
          "INS_PREPAID = #{insPrepaid,jdbcType=DECIMAL},",
          "DUE_TOTAL = #{dueTotal,jdbcType=DECIMAL},",
          "PAID_TOTAL = #{paidTotal,jdbcType=DECIMAL},",
          "BALANCE_TOTAL = #{balanceTotal,jdbcType=DECIMAL},",
          "PAID_BY_CLAIMANT = #{paidByClaimant,jdbcType=DECIMAL},",
          "PAID_TO_CLAIMANT = #{paidToClaimant,jdbcType=DECIMAL},",
          "REJECTION_CODE = #{rejectionCode,jdbcType=VARCHAR},",
          "CLAIMS_STATUS = #{claimsStatus,jdbcType=CHAR},",
          "COMMISSION_FLAG = #{commissionFlag,jdbcType=VARCHAR},",
          "APPROVAL = #{approval,jdbcType=VARCHAR},",
          "APPROVED_BY = #{approvedBy,jdbcType=VARCHAR},",
          "REFERRAL = #{referral,jdbcType=VARCHAR},",
          "INVOICE_ID = #{invoiceId,jdbcType=VARCHAR},",
          "REMARKS = #{remarks,jdbcType=VARCHAR},",
          "DISABILITY_NO = #{disabilityNo,jdbcType=CHAR},",
          "HOSP_INVOICE_NO = #{hospInvoiceNo,jdbcType=VARCHAR},",
          "REMARKS50 = #{remarks50,jdbcType=CHAR},",
          "REMARKS60 = #{remarks60,jdbcType=CHAR},",
          "REMARKS70 = #{remarks70,jdbcType=CHAR},",
          "REMARKS80 = #{remarks80,jdbcType=CHAR},",
          "PROCESSED_FLAG = #{processedFlag,jdbcType=CHAR},",
          "EXPORT40 = #{export40,jdbcType=CHAR},",
          "EXPORT80 = #{export80,jdbcType=CHAR},",
          "CHEQUE_NO = #{chequeNo,jdbcType=VARCHAR},",
          "EXPORT90 = #{export90,jdbcType=CHAR},",
          "CLAIMS_PROCESS_STATUS = #{claimsProcessStatus,jdbcType=CHAR},",
          "CLAIMS_REF_ID = #{claimsRefId,jdbcType=DECIMAL},",
          "TERMINAL_ID = #{terminalId,jdbcType=DECIMAL},",
          "TERMINAL_TYPE = #{terminalType,jdbcType=CHAR},",
          "AVG_LOS = #{avgLos,jdbcType=DECIMAL},",
          "AVG_BILLS = #{avgBills,jdbcType=DECIMAL},",
          "BF_LIMIT = #{bfLimit,jdbcType=DECIMAL},",
          "SECONDARY_DIAGNOSIS = #{secondaryDiagnosis,jdbcType=VARCHAR},",
          "CHEQUE_DATE = #{chequeDate,jdbcType=TIMESTAMP},",
          "PROVIDER_NAME = #{providerName,jdbcType=OTHER},",
          "PANEL_PROVIDER = #{panelProvider,jdbcType=CHAR},",
          "DEDUCTIBLE = #{deductible,jdbcType=DECIMAL},",
          "DEPARTMENT = #{department,jdbcType=VARCHAR},",
          "EMPLOYEE_NAME = #{employeeName,jdbcType=VARCHAR},",
          "POLICY_NO = #{policyNo,jdbcType=VARCHAR},",
          "NEW_IC = #{newIc,jdbcType=VARCHAR},",
          "AGENT_CODE = #{agentCode,jdbcType=VARCHAR},",
          "AGENCY_CODE = #{agencyCode,jdbcType=VARCHAR},",
          "BROKER_CODE = #{brokerCode,jdbcType=VARCHAR},",
          "AGENT_TEAM = #{agentTeam,jdbcType=VARCHAR},",
          "OFFLINE_REASON = #{offlineReason,jdbcType=VARCHAR},",
          "DOCRCV_BY = #{docrcvBy,jdbcType=VARCHAR},",
          "REVIEW_BY = #{reviewBy,jdbcType=VARCHAR},",
          "REVIEW_DATE = #{reviewDate,jdbcType=TIMESTAMP},",
          "SYSTRC = #{systrc,jdbcType=VARCHAR},",
          "DOCSUBMIT_BY = #{docsubmitBy,jdbcType=VARCHAR},",
          "DOCSUBMIT_DATE = #{docsubmitDate,jdbcType=TIMESTAMP},",
          "CHEQUE_SENDTO = #{chequeSendto,jdbcType=VARCHAR},",
          "CHEQUE_TYPE = #{chequeType,jdbcType=VARCHAR},",
          "DELIVERY_TYPE = #{deliveryType,jdbcType=VARCHAR},",
          "PAYLINK_CODE = #{paylinkCode,jdbcType=VARCHAR},",
          "PAYMENT_DESCRIPTION = #{paymentDescription,jdbcType=VARCHAR},",
          "PAYEE_NAME = #{payeeName,jdbcType=VARCHAR},",
          "ADDR1 = #{addr1,jdbcType=VARCHAR},",
          "ADDR2 = #{addr2,jdbcType=VARCHAR},",
          "ADDR3 = #{addr3,jdbcType=VARCHAR},",
          "ADDR4 = #{addr4,jdbcType=VARCHAR},",
          "POSTCODE = #{postcode,jdbcType=VARCHAR},",
          "COUNTRY = #{country,jdbcType=VARCHAR},",
          "AUTOPAY = #{autopay,jdbcType=CHAR},",
          "DOCRCV_CENTRE = #{docrcvCentre,jdbcType=VARCHAR},",
          "THIRD_DIAGNOSIS = #{thirdDiagnosis,jdbcType=VARCHAR},",
          "POLICY_YEAR = #{policyYear,jdbcType=DECIMAL},",
          "CPT_CODE1 = #{cptCode1,jdbcType=VARCHAR},",
          "CPT_CODE2 = #{cptCode2,jdbcType=VARCHAR},",
          "CPT_CODE3 = #{cptCode3,jdbcType=VARCHAR},",
          "CPT_CODE4 = #{cptCode4,jdbcType=VARCHAR},",
          "CPT_CODE5 = #{cptCode5,jdbcType=VARCHAR},",
          "PAST_DIAGNOSIS1 = #{pastDiagnosis1,jdbcType=VARCHAR},",
          "PAST_DIAGNOSIS1_DUR = #{pastDiagnosis1Dur,jdbcType=DECIMAL},",
          "PAST_DIAGNOSIS2 = #{pastDiagnosis2,jdbcType=VARCHAR},",
          "PAST_DIAGNOSIS2_DUR = #{pastDiagnosis2Dur,jdbcType=DECIMAL},",
          "BODY_PART1 = #{bodyPart1,jdbcType=VARCHAR},",
          "BODY_PART2 = #{bodyPart2,jdbcType=VARCHAR},",
          "BODY_PART3 = #{bodyPart3,jdbcType=VARCHAR},",
          "REFERBY_PHYSICIAN = #{referbyPhysician,jdbcType=VARCHAR},",
          "WARNMSG = #{warnmsg,jdbcType=VARCHAR},",
          "ERRMSG = #{errmsg,jdbcType=VARCHAR},",
          "AGENT_UNIT = #{agentUnit,jdbcType=VARCHAR},",
          "ADVANCE_PAYMENT = #{advancePayment,jdbcType=CHAR},",
          "AGENT_HPNO = #{agentHpno,jdbcType=VARCHAR},",
          "CURRCD = #{currcd,jdbcType=VARCHAR},",
          "CURRRT = #{currrt,jdbcType=DECIMAL},",
          "ENGLISH_NAME = #{englishName,jdbcType=VARCHAR},",
          "EST_LOS = #{estLos,jdbcType=DECIMAL},",
          "EST_BILLS = #{estBills,jdbcType=DECIMAL},",
          "SURGICAL_DATE = #{surgicalDate,jdbcType=TIMESTAMP},",
          "CURRCD_ORIG = #{currcdOrig,jdbcType=VARCHAR},",
          "CURRRT_ORIG = #{currrtOrig,jdbcType=DECIMAL},",
          "DUE_TOTAL_ORIG = #{dueTotalOrig,jdbcType=DECIMAL},",
          "BANKACCNO = #{bankaccno,jdbcType=VARCHAR},",
          "LIABILITY_AMT = #{liabilityAmt,jdbcType=DECIMAL},",
          "SELFPAID_COLLECTDT = #{selfpaidCollectdt,jdbcType=TIMESTAMP},",
          "SELFPAID_UPDBY = #{selfpaidUpdby,jdbcType=VARCHAR},",
          "SELFPAID_UPDDT = #{selfpaidUpddt,jdbcType=TIMESTAMP},",
          "SELFPAID_REM = #{selfpaidRem,jdbcType=VARCHAR},",
          "INTERFACE_CLAIM_NO = #{interfaceClaimNo,jdbcType=VARCHAR},",
          "PATIENT_HPNO = #{patientHpno,jdbcType=VARCHAR},",
          "ACCIDENT_DATE = #{accidentDate,jdbcType=TIMESTAMP},",
          "SURGICAL = #{surgical,jdbcType=CHAR},",
          "ACCIDENTAL = #{accidental,jdbcType=CHAR},",
          "EMERGENCY = #{emergency,jdbcType=CHAR},",
          "NOTIFICATION_DATE = #{notificationDate,jdbcType=TIMESTAMP},",
          "DIAGNOSIS_REMARK = #{diagnosisRemark,jdbcType=VARCHAR},",
          "CPT_REMARK = #{cptRemark,jdbcType=VARCHAR},",
          "CHEQUE_REMARK = #{chequeRemark,jdbcType=VARCHAR},",
          "REMINDER = #{reminder,jdbcType=DECIMAL},",
          "COINSRCAP = #{coinsrcap,jdbcType=DECIMAL},",
          "PRIVATE_REMARK = #{privateRemark,jdbcType=VARCHAR},",
          "PREGNANT_MONTH = #{pregnantMonth,jdbcType=DECIMAL},",
          "OUTPATIENT_TREATMENT = #{outpatientTreatment,jdbcType=CHAR},",
          "ADMISSION_REFERRAL = #{admissionReferral,jdbcType=VARCHAR},",
          "CLAIMS_RELATED = #{claimsRelated,jdbcType=VARCHAR},",
          "PAYEE_ICNO = #{payeeIcno,jdbcType=VARCHAR},",
          "POLICY_STATUS = #{policyStatus,jdbcType=DECIMAL},",
          "SMOKER = #{smoker,jdbcType=CHAR},",
          "THIRD_PARTY_POLICY = #{thirdPartyPolicy,jdbcType=CHAR},",
          "POLICY_ENDORSEMENT = #{policyEndorsement,jdbcType=VARCHAR},",
          "MEMBER_ENDORSEMENT = #{memberEndorsement,jdbcType=VARCHAR},",
          "PV_NO = #{pvNo,jdbcType=VARCHAR},",
          "REJECTION_NOTE = #{rejectionNote,jdbcType=VARCHAR},",
          "COINSR_BY_CLAIMANT = #{coinsrByClaimant,jdbcType=DECIMAL},",
          "ORIGIN_CODE = #{originCode,jdbcType=VARCHAR},",
          "PREMIUM_PAID_DATE = #{premiumPaidDate,jdbcType=TIMESTAMP},",
          "INTERFACE_CLAIM_NO2 = #{interfaceClaimNo2,jdbcType=VARCHAR},",
          "POLICY_ENDORSEMENT_CODE = #{policyEndorsementCode,jdbcType=VARCHAR},",
          "REVIEW_REMARK = #{reviewRemark,jdbcType=VARCHAR},",
          "ADMISSION_REMARK = #{admissionRemark,jdbcType=VARCHAR},",
          "ADMISSION_PRIVATE_REMARK = #{admissionPrivateRemark,jdbcType=VARCHAR},",
          "PLAN_START_DATE = #{planStartDate,jdbcType=TIMESTAMP},",
          "PLAN_END_DATE = #{planEndDate,jdbcType=TIMESTAMP},",
          "POLICY_STATUS_CHANGE_DATE = #{policyStatusChangeDate,jdbcType=TIMESTAMP},",
          "MEMBER_STATUS = #{memberStatus,jdbcType=VARCHAR},",
          "POLICY_START_DATE = #{policyStartDate,jdbcType=TIMESTAMP},",
          "MNRB_RISK = #{mnrbRisk,jdbcType=VARCHAR},",
          "FOURTH_DIAGNOSIS = #{fourthDiagnosis,jdbcType=VARCHAR},",
          "FIFTH_DIAGNOSIS = #{fifthDiagnosis,jdbcType=VARCHAR},",
          "INTERFACE_CLAIM_NO3 = #{interfaceClaimNo3,jdbcType=VARCHAR},",
          "CHEQUE_DESPATCH_DATE = #{chequeDespatchDate,jdbcType=TIMESTAMP},",
          "CHEQUE_DESPATCH_BY = #{chequeDespatchBy,jdbcType=VARCHAR},",
          "SCALEDOWN_BY_CLAIMANT = #{scaledownByClaimant,jdbcType=DECIMAL},",
          "SCALEDOWNCAP = #{scaledowncap,jdbcType=DECIMAL},",
          "PATIENT_EMAIL = #{patientEmail,jdbcType=VARCHAR},",
          "AGENT_EMAIL = #{agentEmail,jdbcType=VARCHAR},",
          "PREAUTH_BENEFIT = #{preauthBenefit,jdbcType=VARCHAR},",
          "CENTRE_CODE = #{centreCode,jdbcType=VARCHAR},",
          "SELFPAID_COLLECTAMT = #{selfpaidCollectamt,jdbcType=DECIMAL},",
          "B4ADJUST_DUE_TOTAL_ORIG = #{b4adjustDueTotalOrig,jdbcType=DECIMAL},",
          "B4ADJUST_DUE_TOTAL = #{b4adjustDueTotal,jdbcType=DECIMAL},",
          "B4ADJUST_PAID_TO_CLAIMANT = #{b4adjustPaidToClaimant,jdbcType=DECIMAL},",
          "B4ADJUST_PAID_BY_CLAIMANT = #{b4adjustPaidByClaimant,jdbcType=DECIMAL},",
          "AMT_SETTLE_BY_PAYOR = #{amtSettleByPayor,jdbcType=DECIMAL},",
          "AMT_SETTLE_BY_TPA = #{amtSettleByTpa,jdbcType=DECIMAL},",
          "AMT_SETTLE_BY_PAYOR_DBNNO = #{amtSettleByPayorDbnno,jdbcType=VARCHAR},",
          "AMT_SETTLE_BY_TPA_DBNNO = #{amtSettleByTpaDbnno,jdbcType=VARCHAR},",
          "SELFPAID_RCPTNO = #{selfpaidRcptno,jdbcType=VARCHAR},",
          "SELFPAID_CRNNO = #{selfpaidCrnno,jdbcType=VARCHAR},",
          "HOSP_INVOICE_AMT_ORIG = #{hospInvoiceAmtOrig,jdbcType=DECIMAL},",
          "PREMIUM_GRACE_DATE = #{premiumGraceDate,jdbcType=TIMESTAMP},",
          "MEMBER_PV_NO = #{memberPvNo,jdbcType=VARCHAR},",
          "MEMBER_CHEQUE_NO = #{memberChequeNo,jdbcType=VARCHAR},",
          "MEMBER_CHEQUE_DATE = #{memberChequeDate,jdbcType=TIMESTAMP},",
          "HOSP_INVOICE_TYPE = #{hospInvoiceType,jdbcType=CHAR},",
          "PREAUTH_REQUIRED_TRIGGER = #{preauthRequiredTrigger,jdbcType=VARCHAR},",
          "EBANK_BATCHNO = #{ebankBatchno,jdbcType=VARCHAR},",
          "EBANK_DATE = #{ebankDate,jdbcType=TIMESTAMP},",
          "EBANK_RESPONSE = #{ebankResponse,jdbcType=VARCHAR},",
          "BATCH_NO = #{batchNo,jdbcType=VARCHAR},",
          "BATCH_DATE = #{batchDate,jdbcType=TIMESTAMP},",
          "CLAIMS_SNO = #{claimsSno,jdbcType=DECIMAL},",
          "CLIENT_ID = #{clientId,jdbcType=VARCHAR},",
          "GSTRT = #{gstrt,jdbcType=DECIMAL},",
          "GSTAMT_ORIG = #{gstamtOrig,jdbcType=DECIMAL},",
          "UNIT = #{unit,jdbcType=VARCHAR},",
          "COST_CENTER = #{costCenter,jdbcType=VARCHAR},",
          "SERVICE_FEE = #{serviceFee,jdbcType=DECIMAL},",
          "VATRT = #{vatrt,jdbcType=DECIMAL},",
          "VATAMT_ORIG = #{vatamtOrig,jdbcType=DECIMAL},",
          "WHTRT = #{whtrt,jdbcType=DECIMAL},",
          "WHTAMT_ORIG = #{whtamtOrig,jdbcType=DECIMAL},",
          "LAST_TRANSACTION_DATE = #{lastTransactionDate,jdbcType=TIMESTAMP},",
          "DESIGNATION = #{designation,jdbcType=VARCHAR},",
          "MC_START_DATE = #{mcStartDate,jdbcType=TIMESTAMP},",
          "MC_END_DATE = #{mcEndDate,jdbcType=TIMESTAMP},",
          "PACKAGE_CODE = #{packageCode,jdbcType=VARCHAR},",
          "PACKAGE_DESC = #{packageDesc,jdbcType=OTHER},",
          "PACKAGE_FEE = #{packageFee,jdbcType=DECIMAL},",
          "LEGAL_ENTITY = #{legalEntity,jdbcType=VARCHAR},",
          "OFFICE_CODE = #{officeCode,jdbcType=VARCHAR},",
          "SUBSIDIARY = #{subsidiary,jdbcType=VARCHAR},",
          "DIVISION = #{division,jdbcType=VARCHAR},",
          "SUBDEPARTMENT = #{subdepartment,jdbcType=VARCHAR},",
          "EMPLOYMENT_LOCATION = #{employmentLocation,jdbcType=VARCHAR},",
          "EMPLOYMENT_REGION = #{employmentRegion,jdbcType=VARCHAR},",
          "EMPLOYMENT_CATEGORY = #{employmentCategory,jdbcType=VARCHAR},",
          "EMPLOYMENT_DATE = #{employmentDate,jdbcType=TIMESTAMP},",
          "AMT_DISCOUNT_ORIG = #{amtDiscountOrig,jdbcType=DECIMAL},",
          "AMT_DISCOUNT_MEMBER_ORIG = #{amtDiscountMemberOrig,jdbcType=DECIMAL},",
          "OCCUPATION = #{occupation,jdbcType=VARCHAR},",
          "LAST_CLAIMS_STATUS_DATE = #{lastClaimsStatusDate,jdbcType=TIMESTAMP},",
          "SERVICE_FEE_FORMULA = #{serviceFeeFormula,jdbcType=DECIMAL},",
          "SERVICE_FEE_FORMULA_RATE = #{serviceFeeFormulaRate,jdbcType=DECIMAL},",
          "SERVICE_FEE_GSTRT = #{serviceFeeGstrt,jdbcType=DECIMAL},",
          "SERVICE_FEE_VATRT = #{serviceFeeVatrt,jdbcType=DECIMAL},",
          "SERVICE_FEE_GSTAMT = #{serviceFeeGstamt,jdbcType=DECIMAL},",
          "SERVICE_FEE_VATAMT = #{serviceFeeVatamt,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE = #{payorServiceFee,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE_GSTRT = #{payorServiceFeeGstrt,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE_VATRT = #{payorServiceFeeVatrt,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE_GSTAMT = #{payorServiceFeeGstamt,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE_VATAMT = #{payorServiceFeeVatamt,jdbcType=DECIMAL},",
          "PAYOR_SERVICE_FEE_INVOICE_NO = #{payorServiceFeeInvoiceNo,jdbcType=VARCHAR},",
          "MEMBER_CONTROL_NO = #{memberControlNo,jdbcType=VARCHAR},",
          "DUE_TOTAL_GSTAMT_ORIG = #{dueTotalGstamtOrig,jdbcType=DECIMAL},",
          "DUE_TOTAL_VATAMT_ORIG = #{dueTotalVatamtOrig,jdbcType=DECIMAL},",
          "REFERRAL_PROVIDER_ID = #{referralProviderId,jdbcType=CHAR},",
          "CPF_PREPAID = #{cpfPrepaid,jdbcType=DECIMAL},",
          "CURRCD_PAYOR = #{currcdPayor,jdbcType=VARCHAR},",
          "CURRRT_PAYOR = #{currrtPayor,jdbcType=DECIMAL},",
          "XBORDER = #{xborder,jdbcType=CHAR},",
          "MERCHANT_CODE = #{merchantCode,jdbcType=VARCHAR},",
          "SELFPAID_BY_MEMBER = #{selfpaidByMember,jdbcType=DECIMAL},",
          "SELFPAID_BY_PAYOR = #{selfpaidByPayor,jdbcType=DECIMAL},",
          "SELFPAID_BY_PROVIDER = #{selfpaidByProvider,jdbcType=DECIMAL},",
          "SELFPAID_BY_TPA = #{selfpaidByTpa,jdbcType=DECIMAL},",
          "EST_LOS_ICU = #{estLosIcu,jdbcType=DECIMAL},",
          "USER_CODE = #{userCode,jdbcType=VARCHAR},",
          "LASTEDIT_DATE = #{lasteditDate,jdbcType=TIMESTAMP},",
          "ASSIGNED_CODE = #{assignedCode,jdbcType=VARCHAR},",
          "BIRTH_DATE = #{birthDate,jdbcType=TIMESTAMP},",
          "GENDER = #{gender,jdbcType=CHAR},",
          "CARDSITEID = #{cardsiteid,jdbcType=VARCHAR},",
          "PROVSITEID = #{provsiteid,jdbcType=VARCHAR},",
          "TAXINV_RECEIVE_DATE = #{taxinvReceiveDate,jdbcType=TIMESTAMP},",
          "ORIGBILL_DESPATCH_DATE = #{origbillDespatchDate,jdbcType=TIMESTAMP},",
          "PREPAID_PROVIDER_AMOUNT = #{prepaidProviderAmount,jdbcType=DECIMAL},",
          "PROVIDER_PAYMENT_DUE_DATE = #{providerPaymentDueDate,jdbcType=TIMESTAMP},",
          "PROVIDER_CRTCD = #{providerCrtcd,jdbcType=VARCHAR},",
          "CLAIMSLIST_RECEIVE_DATE = #{claimslistReceiveDate,jdbcType=TIMESTAMP},",
          "LAST_TRANSACTION_STATUS = #{lastTransactionStatus,jdbcType=CHAR},",
          "LAST_TRANSACTION_REASON = #{lastTransactionReason,jdbcType=VARCHAR},",
          "INS_PREPAID_CRCD = #{insPrepaidCrcd,jdbcType=VARCHAR},",
          "ADMISSION_REASON = #{admissionReason,jdbcType=OTHER},",
          "CAUSE_AND_PATHOLOGY = #{causeAndPathology,jdbcType=OTHER},",
          "POSSIBILITY_RELAPSE = #{possibilityRelapse,jdbcType=OTHER},",
          "UNDERLYING_MEDICAL_COND = #{underlyingMedicalCond,jdbcType=OTHER},",
          "PROGNOSIS = #{prognosis,jdbcType=OTHER},",
          "DISCHARGE_MEDICATION = #{dischargeMedication,jdbcType=OTHER},",
          "FOLLOWUP_INSTRUCTION = #{followupInstruction,jdbcType=OTHER},",
          "OTHER_THERAPEUTIC_PROCEDURE = #{otherTherapeuticProcedure,jdbcType=OTHER},",
          "MRN = #{mrn,jdbcType=VARCHAR}",
        "where CLAIMS_ID = #{claimsId,jdbcType=DECIMAL}"
    })
    int updateByPrimaryKey(Claims record);
    
    
    
    List<Map<String,Object>> queryAuthorInfoList(Map<String,Object> map);
    List<Map<String,Object>> queryAuthorDetilById(Integer claimsId);
}